Page two is the comps table — the part owners read first. Pull every qualifying industrial sale that closed in the county this quarter, capture the seven fields below for each, then curate down to the 8–10 that tell the market's story. Lead with the deals you brokered.
1Property & submarketCol 1
The name owners would recognize, plus the city or submarket — Merced, Atwater, Los Banos, Livingston.
FindDeal file · CoStar property record · Crexi listing
2Building AreaCol 2
Total building area in square feet (SF) — the basis for price/SF. Confirm gross vs. rentable basis.
FindCoStar property record · OM / property record
3Sale priceCol 3
Gross consideration — the total trade price, not per SF. Verify against the recorder when a source looks rounded.
FindCoStar sale comp · County Recorder · your file
4Price / SFCol 4
Sale price ÷ SF — the comparability metric, and the number that feeds the page-one median. Double-check the math.
FindCoStar computes it · or divide it yourself
5Cap rateCol 5
Going-in yield, only if disclosed. Many private trades won't report one.
RuleIf undisclosed, leave an em-dash —. Never estimate it.
6Year builtCol 6
Original vintage. If a major renovation drove the price, note it in the read rather than the table.
FindCoStar · County Assessor
7Close dateCol 7
Recording date — must fall inside the quarter. Sort the finished table newest-first.
FindCoStar · County Recorder
∑Footer medianTotal row
After curating, compute the median of SF, price, $/SF, and cap across the kept trades — that's the table's bottom row.
NoteMedian, not average, so one outlier can't skew it.
Log each qualifying trade, then strike the rows you cut. Aim to keep 8–10, with a spread of submarkets and your own deals included.
| Property / Submarket |
SF |
Sale Price |
$ / SF |
Cap |
Built |
Closed |
| 01 | | | | | | |
| 02 | | | | | | |
| 03 | | | | | | |
| 04 | | | | | | |
| 05 | | | | | | |
| 06 | | | | | | |
| 07 | | | | | | |
| 08 | | | | | | |
| 09 | | | | | | |
| 10 | | | | | | |
| Quarter median | | | | | | |
Curate
When more than ten qualify, keep the ones that tell the story: the largest trades, a spread of submarkets, and any you brokered. De-identify if a seller asked to stay private — abstract the name, keep the numbers. Never pad the table with weak or off-market deals to reach ten.
Then write the read
Below the table, the "What this means for owners" note interprets the numbers in three moves — did the market firm, soften, or surge; what moved most; what it means for an owner weighing a transition. Keep it ~120 words, calm and advisory. Full guidance in the Data-Capture Playbook, Step 3.